﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="sample.aspx.cs" Inherits="HRDexCapstoneProject.Functions.sample" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
        DataSourceID="SqlDataSource1" DataKeyNames="EmployeeID">
        <Columns>
<asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" ReadOnly="True" 
                SortExpression="EmployeeID"></asp:BoundField>
            <asp:BoundField DataField="catUserLevelName" HeaderText="catUserLevelName" 
                SortExpression="catUserLevelName" />
            <asp:BoundField DataField="catPositionsName" HeaderText="catPositionsName" 
                SortExpression="catPositionsName" />
            <asp:BoundField DataField="DepartmentName" HeaderText="DepartmentName" 
                SortExpression="DepartmentName" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:HRmainConnectionString %>" 
        
        
        
        
        
        
        
        
        SelectCommand="SELECT formEmployees.EmployeeID, catUserLevel.catUserLevelName, catPositions.catPositionsName, catDepartment.DepartmentName FROM formEmployees INNER JOIN catUserLevel ON formEmployees.UserLevelID = catUserLevel.UserLevelID INNER JOIN catPositions ON formEmployees.catPositionsID = catPositions.catPositionsID INNER JOIN catDepartment ON formEmployees.DeptID = catDepartment.DeptID">
    </asp:SqlDataSource>
    </form>
</body>
</html>
